<?php 
	require_once('connexion.php'); 
	?>

<?php
 $q=$_GET["q"];
 
	//enum societe		

				 
	$query_clients = $pdo->prepare("SELECT * FROM clients where societe_id='$q' "); 
	$query_clients->execute();
	$data_clients = $query_clients->fetchAll();
	
	
  ?>
  
 
		<td>client  (id )</td>
			<td>
				<select name="clientid"  id="clientid">
				<option value =""></option>";
				<?php
					foreach($data_clients as $row )
					{
					echo "<option value =".$row['client_id'].">$row[societe_id] $row[client_id] $row[client_nom] $row[client_prenom]</option>";
					}
				?>
				</select>
			</td>	
<?php

$query_clients->closeCursor();

?>
  